UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ph0Bs0zRnOcX07wyMMr0FgUPtU5QQCF7C6zk7t6ZMGA='
WHERE
key_id = '74ef20c3cd58917dc79fe63bb6a3b9e7037df0abc19472825a47999d1f635744'
AND (
token = 'ph0Bs0zRnOcX07wyMMr0FgUPtU5QQCF7C6zk7t6ZMGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)