UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zK27iyeVDoUqaqxWvFPgWdtq04thSkP0F3gpdxaeVmk='
WHERE
key_id = 'd23dcf6de06ef0947c59c2687367b95b8a39aacf81aba5a2aae736d9affdc8d7'
AND (
token = 'zK27iyeVDoUqaqxWvFPgWdtq04thSkP0F3gpdxaeVmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)