UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cRGgnoU3vmcp0HhSHWloQuIQD4FEJPwGzh0EfkhvAAI='
WHERE
key_id = '312c78ea9d441dc620b170ab066c0fc95c095b11cdc18533042fa49749d1c8b8'
AND (
token = 'cRGgnoU3vmcp0HhSHWloQuIQD4FEJPwGzh0EfkhvAAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)