UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HeEgQ20Ax409MIg1Lkjal4weFLd+DJ8u4ZIl/crqNbI='
WHERE
key_id = '0678c35625cced26cc290b2b270f8b7c1192275e7723266defbc0d3b66c180ea'
AND (
token = 'HeEgQ20Ax409MIg1Lkjal4weFLd+DJ8u4ZIl/crqNbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)