UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hOJB/cCBeu3aqq+yKTtXy6Uhb8WBC0rI5g5Glz5Rds='
WHERE
key_id = '17ae194a1be6940eb101e20a28bc23eae69cfefb6951228fc740a30813d19aed'
AND (
token = '9hOJB/cCBeu3aqq+yKTtXy6Uhb8WBC0rI5g5Glz5Rds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)