UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGT/mHgBsv6TAh+rzKa/yX5mmjY3+gHt2gKmvFaT4ME='
WHERE
key_id = 'c7e6173e9c1e85a5a0751eaf28bc7fb01a1e4a8cc18b3fb4600185fa2ac1e858'
AND (
token = 'zGT/mHgBsv6TAh+rzKa/yX5mmjY3+gHt2gKmvFaT4ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)