UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6kNC4nRQPDW63J6naZwIi6QGAlwLOLzZJidh5cjiTvY='
WHERE
key_id = '2ebe536476e1487996907efeaeaba2805f8cad2c15fee26f132c71fe744fa929'
AND (
token = '6kNC4nRQPDW63J6naZwIi6QGAlwLOLzZJidh5cjiTvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)