UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '14Q387UCzy0ilYZp7Ionp5RYEm9PvohahrH6b4K3Jr4='
WHERE
key_id = '58282d4d240994b3899c7ddee75be4d338b16944cdc6f3048ea34093b44a1ce1'
AND (
token = '14Q387UCzy0ilYZp7Ionp5RYEm9PvohahrH6b4K3Jr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)