UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0tzSTEuh6sBFPN07WxQ87JlxMCwBh1z6Ae7jut6G0G8='
WHERE
key_id = '116f1e21b9f34e8c7384b35eb98a16546ba2afabdfbb7d0707a5f244516c4764'
AND (
token = '0tzSTEuh6sBFPN07WxQ87JlxMCwBh1z6Ae7jut6G0G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)