UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZ1iJKERhkz2WAPR5v1+kHPPdzoMS5JfAkx9z8STlRU='
WHERE
key_id = 'aa110006f22f6f2137f10cbcbb3c416b8299858951c408fb47b099cc10144e66'
AND (
token = 'yZ1iJKERhkz2WAPR5v1+kHPPdzoMS5JfAkx9z8STlRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)