UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bob+VO3yA18hdYlpiO/LiWX2QYSwk7eeX2oCVpfmdOE='
WHERE
key_id = '59706cf47917623af84bcd79dd5edf4641d6fef697e890e6dbba1715e3d6c878'
AND (
token = 'Bob+VO3yA18hdYlpiO/LiWX2QYSwk7eeX2oCVpfmdOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)