UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VjK+OD92XXor59jQzXKGmXETrm0xLNxzGchVTb9DkR8='
WHERE
key_id = 'e39bceb7f7c0df77352999280faef55e8d1e3644140594effca721a9e55580ab'
AND (
token = 'VjK+OD92XXor59jQzXKGmXETrm0xLNxzGchVTb9DkR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)