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