UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fIv67O3BcZLNAkpdg7kqIkItxyNA+LGYCh51OqXBNB8='
WHERE
key_id = 'ecf02ee23543f3bce865a772fefd26d74a28af129b968fff095c6d8311c04993'
AND (
token = 'fIv67O3BcZLNAkpdg7kqIkItxyNA+LGYCh51OqXBNB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)