UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgBjWZTYbV/XgCPJfZr4rn08JVuTyHSla0w/ZhQqp4I='
WHERE
key_id = 'a1759dab793179be681f94b0ac7c55a124f2741a9c55b94850a25d37c21931a7'
AND (
token = 'KgBjWZTYbV/XgCPJfZr4rn08JVuTyHSla0w/ZhQqp4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)