UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9eY333W2nI67J8rSL2t0d2w6PvAzabQhL0AJlbmZeM='
WHERE
key_id = '19ee64be845edfa2ecbf13dce5a2a34f08b82b0371e6a800c0aa8b6c7fdb8b23'
AND (
token = 'b9eY333W2nI67J8rSL2t0d2w6PvAzabQhL0AJlbmZeM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)