UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qwnhNlyKTcEa8r+acXvHWjG6Zr+T293QWIkxg+nden8='
WHERE
key_id = '6d3e37710f2e95ee8c0ee1d104c235c922e05a0f8f3aa29557de37704f2342b7'
AND (
token = 'qwnhNlyKTcEa8r+acXvHWjG6Zr+T293QWIkxg+nden8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)