UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HJtxp2PrEC9Vmp8Bs/00k7hqZg7UNftSL3SNNCO+cg='
WHERE
key_id = '874b49af15b36caf8b615f5ef19db94f605fe32794163c36adaf1c1ed4847831'
AND (
token = '4HJtxp2PrEC9Vmp8Bs/00k7hqZg7UNftSL3SNNCO+cg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)