UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJyhxElQ9D/9pubjZQSyIk76mPEgLbvqUCGowvVsua0='
WHERE
key_id = 'a1f7211d672cbce158c7c2ff8e47a7455353aec429bd03551d9b15c95dc3b571'
AND (
token = 'zJyhxElQ9D/9pubjZQSyIk76mPEgLbvqUCGowvVsua0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)