UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kdH5NSOIkHD3hO0J87mZUKS/zYoxkgqfiobI6Qp6xPo='
WHERE
key_id = 'ca8e5a07e8238f1d98131351012ac7ff447208f58c03c56cbf571bd5c5ad4129'
AND (
token = 'kdH5NSOIkHD3hO0J87mZUKS/zYoxkgqfiobI6Qp6xPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)