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