UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jOVUNRm0EsGegiaDrDeeudHAh34EC6pFQpoI6tuwTxA='
WHERE
key_id = 'd856332b338d24c8cbb97c4742acc0ffc16d3431e3c5dbb20c72a29c242a69d1'
AND (
token = 'jOVUNRm0EsGegiaDrDeeudHAh34EC6pFQpoI6tuwTxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)