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