UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WWQ7EJzCuq4TkpwYDdfcA5ZPSP5xAmY7EbB6h67jBvM='
WHERE
key_id = '47ead50f324716cd93c7b2423792dfb0961d89c5addba86da206bd44258cecd4'
AND (
token = 'WWQ7EJzCuq4TkpwYDdfcA5ZPSP5xAmY7EbB6h67jBvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)