UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dMjuByffSqPmLZuFUpo93rozvGQvqblEmoQPbksj/8='
WHERE
key_id = '3093ce534a45c7a328840841c87a05465dc01e41b08a3d725fac0bf15b35fd1d'
AND (
token = '0dMjuByffSqPmLZuFUpo93rozvGQvqblEmoQPbksj/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)