UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yXUaydz0w+1JE7V12EUC3MOVDEDN3jFsH9Utu4T0gOE='
WHERE
key_id = '4886188517ead1a38e838a51e27edcea98e6969b6a5e4189aa021999c98a1b74'
AND (
token = 'yXUaydz0w+1JE7V12EUC3MOVDEDN3jFsH9Utu4T0gOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)