UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GA7TjAkoIBUhO0GA25E21BJREcBpcAnKsM+vLT7GttE='
WHERE
key_id = 'cb3978c7684fdc34122694bcf66d5345fae07877e8261cf9e163a78acd86a653'
AND (
token = 'GA7TjAkoIBUhO0GA25E21BJREcBpcAnKsM+vLT7GttE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)