UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGXjbhuJlJmmctjS1L+qtvTOjRsfY+jkI2hDa2q4cmc='
WHERE
key_id = '1e2234c6640e6f064f5628d35375b460742790e6ed229240db05e92dd5c67983'
AND (
token = 'zGXjbhuJlJmmctjS1L+qtvTOjRsfY+jkI2hDa2q4cmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)