UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DrvZMJu34IC9Mq5432P04EMeg5uz3kuwNVjXJ83DKzQ='
WHERE
key_id = 'e3ad1d47cb45d7f85887fa7f31c236fa70d384c083be009b8b7d529d83ac0765'
AND (
token = 'DrvZMJu34IC9Mq5432P04EMeg5uz3kuwNVjXJ83DKzQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)