UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rDDGS9JiNXpXj/jGJ+3gKuhhhWTIKQ7qoE/W4cVI5V8='
WHERE
key_id = '558fae6b0833683fa32f6341900352f849364415a74873d18f8c900a179efeae'
AND (
token = 'rDDGS9JiNXpXj/jGJ+3gKuhhhWTIKQ7qoE/W4cVI5V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)