UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't0tXCiWEdM6RYzmIGKn6bGhQamOcLLydmRhPEfFQ/ns='
WHERE
key_id = 'dc978b3c72bfc367e4c836334e28b165c48d6dd81be7860d49596ecfd654c56f'
AND (
token = 't0tXCiWEdM6RYzmIGKn6bGhQamOcLLydmRhPEfFQ/ns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)