UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n/an0kDPLZZI5a6UqK8g0xgT25dzaIJud+bfN3QTT2g='
WHERE
key_id = '96f4b718733809ecac494a039cb6eb6566662c3580d69c2b1d95e2892a29e3f2'
AND (
token = 'n/an0kDPLZZI5a6UqK8g0xgT25dzaIJud+bfN3QTT2g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)