UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4SaM4sFSbwDqsnO79s/Y7emzIOOvgib7CXW+MxpsqlM='
WHERE
key_id = 'd12b84f89b4784b59c169c9a1a432892f1122b4f483715a5aaa998715492928a'
AND (
token = '4SaM4sFSbwDqsnO79s/Y7emzIOOvgib7CXW+MxpsqlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)