UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tpAr0ED8YL5RxKbIleHr6LQrmhDd+u2H3VKRawiOPtM='
WHERE
key_id = 'dfe1867a7a459f930c284fedfc79d3a9e4f4e9f21c8d40cccfd4171b3f09a6a6'
AND (
token = 'tpAr0ED8YL5RxKbIleHr6LQrmhDd+u2H3VKRawiOPtM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)