UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UcKj0zAo+oxxAhupa0CsVVBNFmPgPa/taVTuyrE7yLU='
WHERE
key_id = 'deb67b332460fce2aa845b6f1a298941ec1694b9c75f3d5a890b720dc6f0926b'
AND (
token = 'UcKj0zAo+oxxAhupa0CsVVBNFmPgPa/taVTuyrE7yLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)