UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8T6yhD7OU2bVJSJ5u7H6lstAr842tzI1ih5y/nTk7pM='
WHERE
key_id = 'f129d64b7f801fbda519ef1f8ad868e5aa377c50da157535140c524b552297bb'
AND (
token = '8T6yhD7OU2bVJSJ5u7H6lstAr842tzI1ih5y/nTk7pM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)