UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sQnmKiSCzZ7A0UzvHxnjDlTmrt8jCz9ydsVo5NYIuw='
WHERE
key_id = '9d2379c8439c6c2a5db06f19cbe08ee3cdfd03ddf5e5d4c254fd9ff71f91eb61'
AND (
token = '0sQnmKiSCzZ7A0UzvHxnjDlTmrt8jCz9ydsVo5NYIuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)